Loan Repayment Calculator
Applies the equal-payment, equal-principal and bullet formulas to build a month-by-month schedule in real time.
Repayment schedule
| No. | Payment | Principal | Interest | Balance |
|---|
Applies the equal-payment, equal-principal and bullet formulas to build a month-by-month schedule in real time.
| No. | Payment | Principal | Interest | Balance |
|---|
Enter the loan amount, term in months and annual interest rate, pick a repayment method (equal payments, equal principal or interest-only with a balloon at maturity), and you instantly see the total repaid, total interest, first monthly payment, interest as a share of principal and a month-by-month schedule. The schedule downloads as a CSV file that opens in Excel. Amounts are labelled in Korean won, but the formulas work for any currency. Use it to compare monthly burden and total interest for the same loan.
It uses a monthly rate of annual rate ÷ 12 and the number of months. Equal payments: payment = principal × r × (1 + r)^n ÷ ((1 + r)^n − 1), the same every month, with interest = remaining balance × r. Equal principal: you repay principal ÷ n each month plus interest on the remaining balance. Interest-only: you pay principal × r each month and the whole principal in the last month. With the default 50,000,000 won over 24 months at 4.5%, equal payments come to about 2.18 million a month and about 2.38 million in interest; equal principal starts near 2.27 million and falls to about 2.09 million with about 2.34 million in interest; interest-only is 187,500 a month and 4.5 million in interest. The last instalment absorbs rounding so the balance ends at zero.
Equal principal costs less interest in total but has a higher first payment. Decide by what you can afford each month, and toggle between the two to compare the first payment and total interest.
The annual rate your lender quotes, as a plain percentage such as 4.5. If you get a discount, enter the final rate after it.
You pay interest for more months, and the balance shrinks more slowly so each month's interest stays larger. A shorter term raises the monthly payment but cuts total interest sharply.
No. If you plan to prepay part of it, recalculate with the remaining balance and months afterwards, and check your lender's early-repayment fee.
An estimate, not professional advice. Actual loan terms and payments are set by your lender.